Snowflake Platform SME/Architect
Cincinnati, OH(Remote)
24 Months Contract
Note: Looking for Platform and Automation experience.
JOB DESCRIPTION:
What you will be doing
Work in a globally distributed team to provide robust enterprise data platform in Snowflake
Design, optimize, document and implement the operational aspects in supporting the snowflake cloud platform. Including cost monitoring and optimizations, User security auditing
Implement/support automation for production deployment in Snowflake Implement Snowflake standards and methodologies for DB security-both infrastructure and app level
Implement/support automation Snowflake-Accounts/Databases and access roles
Diagnose and troubleshoot database errors
Implement data sharing/replication-cross cloud/cross region for internal/external clients
Create Snowflake utilization and capacity plan
Tune the DB performance and improve Snowflake queries.
Identify system bottlenecks in the DB and recommend solutions.
Implement Snowflake user/query log analysis and alerts
Implement data encryption/decryption/masking policies to protect PII/PCI data
What you bring:
Hands on experience with Snowflake
Experience implementing Snowflake external functions
Hands-on experience in administering Snowflake in AWS Experience with Agile and DevOps concepts
Knowledge of security (SAML, SCIM, OAuth, OpenID, Kerberos, Policies, entitlements etc.)
Experience with architecting and maintaining high availability production systems
Experience with developing monitoring architecture and implementing monitoring agents, dashboards,
escalations and alerts
Knowledge of security controls for the Public cloud (encryption of data in motion/rest and key
management)
Demonstrated proficiency of index design, query plan optimization and analysis required
Demonstrated knowledge and hands-on experience with AWS alerting/monitoring tools
Experience with AWS CLI and Networking
Strong communication and written skills
Self-starter with ability to take direction and manage tasks with minimal supervision within an energized, collaborative and entrepreneurial environment
Experience & Certification Required:
Snowflake Advanced certification Very nice to have
Snowpro core certification required.
Experience in development of SQL, Python, and Shell based scripting to build a variety of reporting and application data warehouses
Preferred
Experience in Data Ingestion
Data Pipeline
Schema Infrastructure
Real time batch data into Snowflake
Some admin exp
Exp with Change